﻿CREATE TABLE [dbo].[ImageInfo] (
    [ImageID]     UNIQUEIDENTIFIER NOT NULL,
    [CreateTime]  DATETIME         NOT NULL,
    [URI]         VARCHAR (1024)   NOT NULL,
    [UserID]      BIGINT           NULL,
    [ManageID]    INT              NULL,
    [UseType]     VARCHAR (32)     NOT NULL,
    [IsDelete]    BIT              NOT NULL,
    [Description] NVARCHAR (200)   NULL,
    CONSTRAINT [PK_IMAGEINFO] PRIMARY KEY CLUSTERED ([ImageID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片描述', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'Description';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'已删除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'IsDelete';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用途类型', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'UseType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'后台管理员标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'ManageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'URI';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'添加时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'CreateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo', @level2type = N'COLUMN', @level2name = N'ImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ImageInfo';

